insert overwrite table ads_nshop.ads_nshop_customer partition(bdp_day='20220510')
select
    b.customer_gender,
    a.os,
    c.iso,
    a.view_count
from dws_nshop.dws_nshop_ulog_view a
         join ods_nshop.ods_02_customer b
              on a.user_id=b.customer_id
         join ods_nshop.ods_01_base_area c
              on b.customer_natives=c.area_code
where a.bdp_day='20220510';